home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
kermit.columbia.edu
/
kermit.columbia.edu.tar
/
kermit.columbia.edu
/
newsgroups
/
misc.20021006-20030409
/
000221_dba_222@yahoo.com_Fri Jan 17 16:19:10 EST 2003.msg
< prev
next >
Wrap
Text File
|
2003-04-08
|
3KB
|
87 lines
Article: 14012 of comp.protocols.kermit.misc
Path: newsmaster.cc.columbia.edu!panix!newsfeed.mathworks.com!arclight.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: dba_222@yahoo.com (Roger Redford)
Newsgroups: comp.databases.oracle.server,comp.security.ssh,comp.terminals,comp.protocols.kermit.misc
Subject: Re: Strange behavior with SQLPLUS (Oracle)
Date: 17 Jan 2003 13:17:46 -0800
Organization: http://groups.google.com/
Lines: 68
Message-ID: <a8c29269.0301171317.2c874c13@posting.google.com>
References: <a8c29269.0301140753.7ee5175c@posting.google.com>
NNTP-Posting-Host: 205.181.14.12
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1042838267 21689 127.0.0.1 (17 Jan 2003 21:17:47 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 17 Jan 2003 21:17:47 GMT
Xref: newsmaster.cc.columbia.edu comp.databases.oracle.server:215244 comp.security.ssh:30831 comp.terminals:17744 comp.protocols.kermit.misc:14012
Hi guys,
Thanks for all your responses. With sqlplus I tried all these things:
set trimspool on/off
set linesize
copying environments
and it made no difference. I still had the same symptom.
Only formatting the column works. Which, as I mentioned, is a lot
more work for every ad hoc query.
I'm thinking that this is really not a sqlplus issue, but a
terminal issue. Any ideas?
Thanks
dba_222@yahoo.com (Roger Redford) wrote in message news:<a8c29269.0301140753.7ee5175c@posting.google.com>...
> I've recently moved to a new environment, and I'm getting some strange
> symptoms with sqlplus. The environment is:
>
> Oracle 9.2, on solaris
> Ibm thinkpad laptop
> Smarterm and Putty
>
> I've used both Smarterm and Putty to connect to unix and use sqlplus. It is
> using SSH, but the symptoms occur whether I am just using telnet, or ssh.
>
>
> The symptom is:
>
> When do I select some long columns, such as TABLE_OWNER,
> OR table_name, the field takes up a whole line.
>
>
> IE.
>
> Select table_owner ,
> table_name ,
> partition_name,
> NUM_ROWS,
> LAST_ANALYZED
> from all_tab_partitions
> where NUM_ROWS = 0
> ORDER BY TABLE_OWNER,
> TABLE_NAME,
> PARTITION_NAME
>
>
> I have tried:
> set linesize 30000
> substr(table_owner, 1, 20) as table_owner
>
> Yet, no matter what I do, the symptoms persist.
>
> Set wrap is on. If I set it off, I will only see the first field.
>
> The crazy thing is, that my neighbors' sqlplus works normally,
> and only returns 30 or less columns.
>
>
> Is there a setting that I should be concerned about? Is it in
> sqlplus, or in the client software (Putty, or Smarterm)?
>
>
> Thanks